/*
 Navicat Premium Data Transfer
 Source Server         : localhost
 Source Server Type    : MariaDB
 Source Server Version : 100206
 Source Host           : localhost
 Source Database       : any
 Target Server Type    : MariaDB
 Target Server Version : 100206
 File Encoding         : utf-8
 Date: 06/07/2017 17:05:08 PM
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ------------
-- Table structure for 'user'
-- ------------
DROP TABLE IF EXISTS 'user';
CREATE TABLE 'user' (
  'id' BIGINT(20) NOT NULL AUTO_INCREMENT,
  'username' VARCHAR(255) CHARACTER SET utf8mb4 COLLATE uft8mb4_bin DEFAULT null COMMENT '账号',
  'password' VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '密码',
  'nickname' VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '昵称',
  'roles' VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '身份',
  PRIMARY KEY ('id')
)ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

-- -------------
-- records of 'user'
-- -------------
BEGIN ;
INSERT INTO 'user' VALUES (1, 'anoy', 'pwd', 'anoy', 'ROLE_USER'), (2, 'admin', 'pwd', 'admin', 'ROLE_USER,ROLE_ADMIN');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;